DATA EXPORT: 
2014_Q1 - 67,266,255 rows 4.7GB uncompressed  1.1GB compressed 1hr37min
2014_Q2 - 70,670,187 rows 4.9GB uncompressed  1.2GB compressed 2hr00min
2014_Q3 - 64,407,066 rows 4.5GB uncompressed  1.1GB compressed 2hr15min
2014_Q4 - 65,198,754 rows 4.5GB uncompressed  1.1GB compressed 1hr34min
2015_Q1 - 64,730,289 rows 4.5GB uncompressed  1.1GB compressed 2hr00min
2015_Q2 - 67,458,416 rows 4.7GB uncompressed  1.1GB compressed 1hr42min
2015_Q3 - 75,852,147 rows 5.2GB uncompressed  1.2GB compressed 1hr48min
2015_Q4 - 76,085,778 rows 5.2GB uncompressed  1.3GB compressed 2hr10min
2016_Q1 - 77,485,962 rows 5.3GB uncompressed  1.3GB compressed 1hr48min

FIELDS: 
SERIAL_NUMBER, NUMBER(11), --RowID
ROUTE VARCHAR2(43) -- Route
DIRECTION_NAME, VARCHAR2(50), --North, South, East, West
VEHICLE_NUMBER, NUMBER(11), --Bus ID
SURVEY_DATE, VARCHAR2(10), -- mm-dd-yyyy
TIME_ACTUAL_ARRIVE, VARCHAR2(8), --hh24:mi:ss
PASSENGERS_ON, FLOAT, 
PASSENGERS_OFF, FLOAT, 
PASSENGERS_IN, FLOAT, 
LATITUDE_ACTUAL, FLOAT(22), 
LONGITUDE_ACTUAL, FLOAT(22)

SAMPLE DATA: 
49796964,60,West,1694,01-04-2016,08:37:41,0,2.244,10.375,41.87178,-87.64692
49796964,60,West,1694,01-04-2016,08:39:28,0,0,9.253,41.87438,-87.65026
49796964,60,West,1694,01-04-2016,08:44:08,0,1.122,5.938,41.86541,-87.65667
49796964,60,West,1694,01-04-2016,08:45:31,0,0,5.938,41.86168,-87.658
49796964,60,West,1694,01-04-2016,08:57:40,0,0,5.938,41.84484,-87.68819
49796964,60,West,1694,01-04-2016,08:55:08,0,0,5.938,41.8486,-87.67556
49796964,60,West,1694,01-04-2016,08:58:39,0,0,5.938,41.84475,-87.69452
49796964,60,West,1694,01-04-2016,09:02:58,0,0,4.704,41.84444,-87.71228
49796964,60,West,1694,01-04-2016,09:02:43,0,0,4.704,41.84446,-87.70982
49796964,60,West,1694,01-04-2016,08:26:26,0,5.63,12.495,41.88215,-87.6364

QUERY: 
CREATE OR REPLACE VIEW MH_RCM_APC_FOIA_REQ AS
SELECT /*+ NO_INDEX(B RCD_SERIAL_NUMBER_SORT_ORDER) */
       a.SERIAL_NUMBER, substr(a.ROUTE_NAME,8) ROUTE, a.DIRECTION_NAME, a.VEHICLE_NUMBER,
       to_char(a.SURVEY_DATE, 'mm-dd-yyyy') SURVEY_DATE,
       to_char(b.TIME_ACTUAL_ARRIVE, 'hh24:mi:ss') TIME_ACTUAL_ARRIVE,
       b.PASSENGERS_ON, b.PASSENGERS_OFF, b.PASSENGERS_IN,
       b.LATITUDE_ACTUAL, b.LONGITUDE_ACTUAL
FROM ridecheck_plus.RIDE_CHECK_MASTER A, ridecheck_plus.RIDE_CHECK_DETAIL B
WHERE a.SERIAL_NUMBER=b.SERIAL_NUMBER
  AND a.SURVEY_DATE BETWEEN '01-JAN-14' AND '01-APR-14';
;